Predicates

You can use THIS variable to iterate through object elements, filter objects by type, filter object fields against a specified condition.

Using THIS for filtering

-- select just size that meets the condition
SELECT order.info.size[this > 500] FROM orders

-- select just LimitOrder types or Orders
SELECT order[this is deltix.orders.LimitOrder].info.* FROM orders

-- select correlationId where source is LO_SOURCE, otherwise return NULL
SELECT order.id[source == 'LO_SOURCE'].correlationId FROM orders